{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>low</th>\n",
       "      <th>total_turnover</th>\n",
       "      <th>close</th>\n",
       "      <th>num_trades</th>\n",
       "      <th>limit_up</th>\n",
       "      <th>limit_down</th>\n",
       "      <th>volume</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-03-10</th>\n",
       "      <td>4.08</td>\n",
       "      <td>2.546598e+07</td>\n",
       "      <td>4.09</td>\n",
       "      <td>2908.0</td>\n",
       "      <td>4.54</td>\n",
       "      <td>3.72</td>\n",
       "      <td>6129016.0</td>\n",
       "      <td>4.26</td>\n",
       "      <td>4.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-11</th>\n",
       "      <td>4.03</td>\n",
       "      <td>3.035027e+07</td>\n",
       "      <td>4.21</td>\n",
       "      <td>3579.0</td>\n",
       "      <td>4.50</td>\n",
       "      <td>3.68</td>\n",
       "      <td>7253204.0</td>\n",
       "      <td>4.30</td>\n",
       "      <td>4.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-12</th>\n",
       "      <td>4.16</td>\n",
       "      <td>5.731667e+07</td>\n",
       "      <td>4.42</td>\n",
       "      <td>10361.0</td>\n",
       "      <td>4.63</td>\n",
       "      <td>3.79</td>\n",
       "      <td>13122895.0</td>\n",
       "      <td>4.49</td>\n",
       "      <td>4.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-15</th>\n",
       "      <td>4.39</td>\n",
       "      <td>1.105771e+08</td>\n",
       "      <td>4.86</td>\n",
       "      <td>8739.0</td>\n",
       "      <td>4.86</td>\n",
       "      <td>3.98</td>\n",
       "      <td>23415491.0</td>\n",
       "      <td>4.86</td>\n",
       "      <td>4.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-16</th>\n",
       "      <td>5.35</td>\n",
       "      <td>6.590195e+07</td>\n",
       "      <td>5.35</td>\n",
       "      <td>2665.0</td>\n",
       "      <td>5.35</td>\n",
       "      <td>4.37</td>\n",
       "      <td>12318121.0</td>\n",
       "      <td>5.35</td>\n",
       "      <td>5.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-17</th>\n",
       "      <td>5.89</td>\n",
       "      <td>2.779356e+07</td>\n",
       "      <td>5.89</td>\n",
       "      <td>1360.0</td>\n",
       "      <td>5.89</td>\n",
       "      <td>4.82</td>\n",
       "      <td>4718770.0</td>\n",
       "      <td>5.89</td>\n",
       "      <td>5.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-18</th>\n",
       "      <td>6.02</td>\n",
       "      <td>6.896758e+08</td>\n",
       "      <td>6.48</td>\n",
       "      <td>35915.0</td>\n",
       "      <td>6.48</td>\n",
       "      <td>5.30</td>\n",
       "      <td>108723518.0</td>\n",
       "      <td>6.48</td>\n",
       "      <td>6.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-19</th>\n",
       "      <td>6.14</td>\n",
       "      <td>9.281842e+08</td>\n",
       "      <td>6.87</td>\n",
       "      <td>83411.0</td>\n",
       "      <td>7.13</td>\n",
       "      <td>5.83</td>\n",
       "      <td>139087883.0</td>\n",
       "      <td>7.12</td>\n",
       "      <td>6.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-22</th>\n",
       "      <td>6.54</td>\n",
       "      <td>7.070684e+08</td>\n",
       "      <td>7.56</td>\n",
       "      <td>57080.0</td>\n",
       "      <td>7.56</td>\n",
       "      <td>6.18</td>\n",
       "      <td>100705316.0</td>\n",
       "      <td>7.56</td>\n",
       "      <td>6.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-23</th>\n",
       "      <td>7.18</td>\n",
       "      <td>1.009227e+09</td>\n",
       "      <td>8.32</td>\n",
       "      <td>74794.0</td>\n",
       "      <td>8.32</td>\n",
       "      <td>6.80</td>\n",
       "      <td>127027051.0</td>\n",
       "      <td>8.32</td>\n",
       "      <td>7.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-24</th>\n",
       "      <td>8.75</td>\n",
       "      <td>4.638337e+08</td>\n",
       "      <td>9.15</td>\n",
       "      <td>29936.0</td>\n",
       "      <td>9.15</td>\n",
       "      <td>7.49</td>\n",
       "      <td>51111322.0</td>\n",
       "      <td>9.15</td>\n",
       "      <td>9.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-25</th>\n",
       "      <td>8.24</td>\n",
       "      <td>1.406457e+09</td>\n",
       "      <td>8.78</td>\n",
       "      <td>122203.0</td>\n",
       "      <td>10.07</td>\n",
       "      <td>8.24</td>\n",
       "      <td>159859689.0</td>\n",
       "      <td>10.00</td>\n",
       "      <td>9.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-26</th>\n",
       "      <td>7.90</td>\n",
       "      <td>1.084878e+09</td>\n",
       "      <td>8.20</td>\n",
       "      <td>97696.0</td>\n",
       "      <td>9.66</td>\n",
       "      <td>7.90</td>\n",
       "      <td>132371665.0</td>\n",
       "      <td>8.64</td>\n",
       "      <td>8.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-29</th>\n",
       "      <td>7.71</td>\n",
       "      <td>1.073137e+09</td>\n",
       "      <td>8.25</td>\n",
       "      <td>96314.0</td>\n",
       "      <td>9.02</td>\n",
       "      <td>7.38</td>\n",
       "      <td>131232671.0</td>\n",
       "      <td>8.49</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-30</th>\n",
       "      <td>7.43</td>\n",
       "      <td>8.168007e+08</td>\n",
       "      <td>7.51</td>\n",
       "      <td>73385.0</td>\n",
       "      <td>9.08</td>\n",
       "      <td>7.43</td>\n",
       "      <td>108642707.0</td>\n",
       "      <td>7.96</td>\n",
       "      <td>7.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-31</th>\n",
       "      <td>7.15</td>\n",
       "      <td>7.424906e+08</td>\n",
       "      <td>7.40</td>\n",
       "      <td>66253.0</td>\n",
       "      <td>8.26</td>\n",
       "      <td>6.76</td>\n",
       "      <td>99402765.0</td>\n",
       "      <td>7.84</td>\n",
       "      <td>7.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-01</th>\n",
       "      <td>7.01</td>\n",
       "      <td>5.871877e+08</td>\n",
       "      <td>7.30</td>\n",
       "      <td>50391.0</td>\n",
       "      <td>8.14</td>\n",
       "      <td>6.66</td>\n",
       "      <td>81607548.0</td>\n",
       "      <td>7.45</td>\n",
       "      <td>7.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-02</th>\n",
       "      <td>6.97</td>\n",
       "      <td>5.391238e+08</td>\n",
       "      <td>6.98</td>\n",
       "      <td>45938.0</td>\n",
       "      <td>8.03</td>\n",
       "      <td>6.57</td>\n",
       "      <td>74883092.0</td>\n",
       "      <td>7.52</td>\n",
       "      <td>7.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-06</th>\n",
       "      <td>6.90</td>\n",
       "      <td>4.933757e+08</td>\n",
       "      <td>7.11</td>\n",
       "      <td>38072.0</td>\n",
       "      <td>7.68</td>\n",
       "      <td>6.28</td>\n",
       "      <td>69771188.0</td>\n",
       "      <td>7.23</td>\n",
       "      <td>6.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-07</th>\n",
       "      <td>7.00</td>\n",
       "      <td>8.267101e+08</td>\n",
       "      <td>7.56</td>\n",
       "      <td>70670.0</td>\n",
       "      <td>7.82</td>\n",
       "      <td>6.40</td>\n",
       "      <td>111218570.0</td>\n",
       "      <td>7.78</td>\n",
       "      <td>7.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             low  total_turnover  close  num_trades  limit_up  limit_down  \\\n",
       "date                                                                        \n",
       "2021-03-10  4.08    2.546598e+07   4.09      2908.0      4.54        3.72   \n",
       "2021-03-11  4.03    3.035027e+07   4.21      3579.0      4.50        3.68   \n",
       "2021-03-12  4.16    5.731667e+07   4.42     10361.0      4.63        3.79   \n",
       "2021-03-15  4.39    1.105771e+08   4.86      8739.0      4.86        3.98   \n",
       "2021-03-16  5.35    6.590195e+07   5.35      2665.0      5.35        4.37   \n",
       "2021-03-17  5.89    2.779356e+07   5.89      1360.0      5.89        4.82   \n",
       "2021-03-18  6.02    6.896758e+08   6.48     35915.0      6.48        5.30   \n",
       "2021-03-19  6.14    9.281842e+08   6.87     83411.0      7.13        5.83   \n",
       "2021-03-22  6.54    7.070684e+08   7.56     57080.0      7.56        6.18   \n",
       "2021-03-23  7.18    1.009227e+09   8.32     74794.0      8.32        6.80   \n",
       "2021-03-24  8.75    4.638337e+08   9.15     29936.0      9.15        7.49   \n",
       "2021-03-25  8.24    1.406457e+09   8.78    122203.0     10.07        8.24   \n",
       "2021-03-26  7.90    1.084878e+09   8.20     97696.0      9.66        7.90   \n",
       "2021-03-29  7.71    1.073137e+09   8.25     96314.0      9.02        7.38   \n",
       "2021-03-30  7.43    8.168007e+08   7.51     73385.0      9.08        7.43   \n",
       "2021-03-31  7.15    7.424906e+08   7.40     66253.0      8.26        6.76   \n",
       "2021-04-01  7.01    5.871877e+08   7.30     50391.0      8.14        6.66   \n",
       "2021-04-02  6.97    5.391238e+08   6.98     45938.0      8.03        6.57   \n",
       "2021-04-06  6.90    4.933757e+08   7.11     38072.0      7.68        6.28   \n",
       "2021-04-07  7.00    8.267101e+08   7.56     70670.0      7.82        6.40   \n",
       "\n",
       "                 volume   high  open  \n",
       "date                                  \n",
       "2021-03-10    6129016.0   4.26  4.20  \n",
       "2021-03-11    7253204.0   4.30  4.06  \n",
       "2021-03-12   13122895.0   4.49  4.18  \n",
       "2021-03-15   23415491.0   4.86  4.41  \n",
       "2021-03-16   12318121.0   5.35  5.35  \n",
       "2021-03-17    4718770.0   5.89  5.89  \n",
       "2021-03-18  108723518.0   6.48  6.30  \n",
       "2021-03-19  139087883.0   7.12  6.14  \n",
       "2021-03-22  100705316.0   7.56  6.76  \n",
       "2021-03-23  127027051.0   8.32  7.86  \n",
       "2021-03-24   51111322.0   9.15  9.15  \n",
       "2021-03-25  159859689.0  10.00  9.70  \n",
       "2021-03-26  132371665.0   8.64  8.30  \n",
       "2021-03-29  131232671.0   8.49  8.10  \n",
       "2021-03-30  108642707.0   7.96  7.79  \n",
       "2021-03-31   99402765.0   7.84  7.27  \n",
       "2021-04-01   81607548.0   7.45  7.21  \n",
       "2021-04-02   74883092.0   7.52  7.30  \n",
       "2021-04-06   69771188.0   7.23  6.95  \n",
       "2021-04-07  111218570.0   7.78  7.00  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "stock_price=pd.read_csv(filepath_or_buffer='test1.csv',sep=',',index_col=0)\n",
    "stock_price.drop(labels=['num_trades','total_turnover','volume'],axis=1,)\n",
    "stock_price\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
